SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53564 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53564 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144851,764890,236654,298111,442931,761579,954813,189826,677461,693216,527826,262169,411301,243405,220770,1016810,788153,513412,670988,884166,359923,725442,630930,53067,890651,793529,347658,572785,10897,570803,389121,588861,976064,71108,507172,480902,118336,532339,829219,878233,673980,173508,413561,574076,215051,808368,930991,120533,543815,1001449,1010171,113150,556419,318212,461612,326500,300673,647987,148180,640365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]