SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434202 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434202 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43466,602897,161785,1005115,119179,333736,447622,66356,946439,843013,24854,933367,147279,890901,388044,712211,671938,157212,1004039,964999,469379,886196,863249,783838,354866,699926,875745,216645,994802,804898,560748,572121,315965,370840,198939,453868,2357,455512,691047,170068,314960,66487,305017,761480,191730,247090,143329,783235,764585,1002886,344479,1018664,524608,660265,620474,266775,397499,496749,398133,215648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]