SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542343 LIMIT 1 [ RunTime:0.003414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542343 [ RunTime:0.004928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716509,436697,747338,152915,862326,220002,99371,1014651,859455,775600,286751,26610,368294,66341,256667,306064,946461,945848,831197,888322,48604,486108,195529,184554,181454,267402,529109,369513,12859,231327,4204,924688,705569,646233,712302,836817,1031039,634266,771835,251966,934594,368214,271292,270477,513811,830104,832356,265104,10550,1033204,510462,353868,448934,133757,715731,54269,427420,845787,424157,908621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]