SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107887 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107887 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801570,614441,526858,1039518,618950,374881,757152,708845,559666,83100,1470,1048683,528571,726466,117474,458865,642227,909459,823564,1025683,336397,1000697,673021,911671,704418,462699,673650,177205,431520,802760,45781,76816,360605,672073,510068,626230,133254,1026027,111128,135090,557069,555255,365734,453709,970591,289200,49139,35270,437560,250571,406294,685293,354902,551605,547120,793394,129214,465076,492011,119094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]