SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514088 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514088 [ RunTime:0.005446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211844,522597,114702,883908,316089,147641,343473,285938,597033,1025630,277269,50497,49306,968727,726478,667724,470734,578212,553089,811780,588462,397865,81705,798737,385996,262906,869715,787127,148627,164804,755382,17699,1008128,494270,175751,702071,824452,703488,854288,413617,137085,549836,483987,676344,960072,114363,517304,907809,1022677,1009046,257965,751358,817486,314076,66413,92564,178957,318726,403273,169331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000881s ]