SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567294 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567294 [ RunTime:0.002574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654387,118496,224536,31552,478393,810415,282219,1030112,472778,1045992,981738,885163,826353,932759,101096,536184,416845,968587,624800,273473,526914,77101,366312,952280,539882,530256,97933,485269,226450,444706,1015755,546257,629170,622582,209698,462459,335657,74783,1030076,242688,711817,485339,349908,707037,145532,778551,437643,748822,105751,514402,504589,780469,305094,129353,476318,149045,278860,99246,555122,972717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]