SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 855515 LIMIT 1 [ RunTime:0.000951s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 855515 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473714,602457,133293,149939,395201,670899,408674,823612,493055,114595,318950,1043776,390140,897846,420630,81084,853952,889386,858521,422572,603839,350100,335970,830131,135257,70695,310066,864172,635834,849052,548860,360961,408908,691042,684248,1034260,367635,775890,1025632,197403,1024912,897693,415759,868909,711220,356283,638686,338802,153082,456179,312268,420325,1043394,758494,319531,403012,491406,661429,981406,398466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 855515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 855515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]