SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450788 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450788 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010,230290,906551,250622,427164,805423,304455,274436,82065,250031,609814,774656,66473,986695,612464,1018985,581121,486691,994154,507747,197285,23581,29171,814533,778344,785161,554776,310084,811562,3974,985424,223876,546370,303242,561816,915569,968133,270282,952132,316706,880771,974472,338245,935805,29902,318242,598408,1043605,914236,795531,561685,15054,976858,881804,356554,948436,781399,377434,257911,891387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450788 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450788 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]