SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506253 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506253 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39833,1024805,549526,639258,697627,756994,767233,449635,61421,288467,341100,289743,671940,410049,156571,973677,880103,165035,86824,6583,321167,856346,650656,226895,43818,591029,768758,580800,695686,797174,981988,868962,845622,133773,715088,765467,952968,782019,1028844,329073,276521,686022,302189,956152,822912,64237,299291,609781,186564,65411,216321,156729,576039,197061,366904,1006535,87977,691299,645596,752112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]