SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564287 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564287 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85716,918588,239848,113037,353127,230027,472605,282661,190226,910438,146034,217612,693820,124059,761547,119850,358976,743053,682496,138375,979814,276651,857044,396735,553094,520531,744155,1019841,41598,126952,408899,10457,874453,500088,661361,914530,565809,214185,580571,153431,469911,198136,745189,255209,777739,1025447,398285,63282,477451,346752,731593,420697,709941,848062,464524,461966,471574,550247,308868,499387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]