SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544267 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544267 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111562,153725,839079,870164,75366,850824,173159,134686,349597,399020,971931,933587,232761,236141,128767,79624,891659,529243,614300,116809,332285,280097,680322,43121,645644,688580,1042359,155095,426573,125521,597010,307182,399848,134030,363685,150699,731122,1045561,564451,594205,41329,885760,401117,127427,566906,839510,180773,220594,1009579,330982,377182,208247,288513,551859,998113,315902,876734,837501,853894,137450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]