SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005554 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005554 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691940,1037947,433018,600554,359017,199648,638479,315103,679714,761744,859268,446491,474330,120190,358492,709335,499827,398747,112643,808660,31643,542476,334870,102992,538579,307538,48343,44509,1047087,108467,584914,563251,86342,387572,555685,905012,316784,99472,539004,9038,317145,10979,414414,409207,914093,16197,676774,558090,902908,182362,448933,154065,68123,434105,69126,1029795,161405,89708,430374,490972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002186s ]