SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318822 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318822 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692378,4950,731508,937329,397063,837918,161230,375867,304862,835634,260019,695459,718926,125700,990278,870931,976816,564861,260201,560680,900741,711525,313868,490217,222821,443195,23503,405393,395409,827087,686557,101191,219025,972720,55083,1023043,878557,482785,450581,250153,624834,566041,754529,156929,64521,333218,554150,182517,1036784,1035513,172954,983864,493120,650387,737676,798035,24219,526908,1034279,314555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000855s ]