SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40603 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40603 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517101,1030414,115751,989880,316003,549998,891032,65075,430445,679878,684876,1001799,929139,991440,149531,799320,658650,78192,305566,285649,490213,367063,6704,247318,446732,60531,415097,540962,219685,242318,73027,1015563,188616,601288,304227,480863,125629,12377,1043570,77449,678389,963878,312035,26004,205706,726820,524072,232438,1046225,787184,238130,958677,76514,725276,163451,104704,887185,605524,547255,239654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]