SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54005 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54005 [ RunTime:0.003154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237971,828438,118543,632731,531448,117863,188579,319000,971970,604834,867452,231873,303304,685467,522092,133037,394532,199695,245189,501374,357769,570686,813962,547048,952610,125234,580957,1019734,574485,309059,163353,858246,775386,317904,729025,84442,8211,566338,364158,925534,874412,523058,904325,129490,397159,591423,916620,243590,628681,536106,316622,495283,743294,70015,267687,591676,988107,201664,1018306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]