SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504539 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504539 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843342,81010,419060,290447,822586,718618,738863,685776,339147,243525,893970,710951,126713,58853,566137,12521,58378,409102,108819,963878,475745,341261,537127,1042058,331893,980063,798090,45422,625461,1011143,466601,319125,136394,801371,900485,129073,139527,587810,121775,169477,844379,968495,586597,170043,1006699,543513,341631,509997,925743,696505,1012250,521477,504537,630509,892293,747356,832873,379408,973863,619014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]