SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555414 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555414 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432030,354966,51269,76806,912168,504309,660372,178864,242945,565059,331756,395218,170438,897934,288351,773677,420580,653597,29217,835837,453752,310737,640762,863359,188313,330645,273440,583114,255100,1012800,160842,569899,721839,1023859,13419,658017,628459,206526,606187,793451,951208,362656,268957,776935,166267,120779,658329,632186,57547,439897,941861,184865,270447,45329,460217,114251,648180,324920,511519,602755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]