SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401234 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401234 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624432,631928,843773,1038945,404070,370556,812124,1013801,343503,307615,340691,94168,249653,270487,513998,12874,310025,720778,795906,302174,575699,883437,379142,542982,664204,745124,638894,876236,551441,751098,651837,76787,833640,318237,340561,630627,101867,303428,554405,815209,393899,892482,647216,395865,144043,947816,646352,730621,324115,955908,937139,748455,1022220,686588,915992,768191,246405,941636,320055,433014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]