SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012029 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012029 [ RunTime:0.002951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000099,12523,477668,207912,47198,318706,893464,809038,819759,237650,232709,866910,434897,704204,902046,601290,454977,539695,106939,1029018,1019019,66982,720317,344109,932860,706129,1002385,85943,285355,382776,117995,573135,730188,621098,297549,871872,1013314,328587,597834,903738,133501,105652,114667,496413,753816,480467,500858,620393,1039606,769287,97290,447591,908999,681423,544591,739855,716537,93430,468669,886103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]