SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803195 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803195 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410039,912869,290042,564834,850769,390371,571195,1035854,604365,624294,149367,590247,583303,335843,682014,133716,916103,612694,79893,162537,398758,1029127,531861,417428,264805,158347,235386,358671,601937,462619,1045158,14753,761320,345224,365518,152501,242025,972766,787798,1032917,58561,388278,431978,83447,151500,134111,347375,443546,1021459,166884,385542,143646,727773,675033,271367,804443,758084,686415,713942,323262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]