SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529693 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529693 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929075,98311,465099,798511,437492,845671,105930,131283,547034,776429,304556,500946,153459,773698,720475,18654,503430,537625,1008464,486781,578854,549761,956630,271654,405185,308396,27214,591189,294245,434636,743660,501573,643499,622064,921603,845585,218377,369519,668979,853205,203275,986760,925161,144112,445589,887491,748970,269582,831841,435457,544327,100535,204593,852244,958077,620888,765569,289839,803386,110358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]