SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020162 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020162 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500519,1017970,70215,857091,877728,125041,594578,707018,732506,67817,511926,866783,645040,28894,1023484,1037607,309985,998092,590528,789185,525410,878165,404393,150083,178722,287467,930149,629730,490311,227173,479026,597334,553376,838569,629179,860256,244301,253238,774903,738384,874915,667980,959227,23150,714044,309395,538565,538659,846851,1036136,369070,456540,378880,540644,520813,275343,445069,995048,66403,282957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]