SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124201 LIMIT 1 [ RunTime:0.002218s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124201 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496697,258739,1038244,200603,202062,867761,660517,83321,640034,132089,107024,519047,139158,560285,667145,767813,356488,651968,55559,49606,779858,405224,705924,559068,494410,279636,210339,109048,161430,279614,402232,623754,966247,152348,914016,583085,615388,932172,18161,942685,977576,175439,552362,176629,942045,1041713,772443,571133,1016482,47997,382160,184411,301272,477941,169732,411924,86830,202310,356744,485615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]