SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454541 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454541 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628877,1009254,721708,257919,247722,172316,276126,608239,151494,431351,1010199,577861,542108,573618,20774,513366,181547,644698,474547,43799,420415,619382,339219,894655,860799,703397,181023,919550,889566,96024,655532,709142,229236,351514,919893,891871,637349,31164,754443,128770,119122,309149,392863,828597,982124,351805,402585,143295,388515,760561,189015,797080,509601,715505,101168,123630,832869,1025978,721145,52372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]