SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593523 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593523 [ RunTime:0.002556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163949,601370,36144,1044680,469676,1031019,1024142,98181,413902,190123,995174,251918,620876,739934,803737,988437,325550,932700,921896,962132,352261,381031,565718,553564,5674,133485,264274,132238,15350,237517,596567,611923,47156,963694,325799,41479,771537,977491,407260,986879,766770,745047,363104,571117,284200,148155,339449,878426,59082,914870,168209,481823,750782,194331,127701,45425,197379,718942,513117,946303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]