SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336116 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336116 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157366,489720,1020794,773919,303252,526321,666475,176978,512538,1014124,696940,230732,214454,158178,641389,212848,635361,285004,1011074,796776,505654,528543,974581,824131,852803,35636,185047,90029,891359,651802,102580,391300,686071,185532,298528,322718,907646,948942,218639,949006,265026,179011,1011139,955262,526910,860397,890922,954391,171921,644610,280836,259864,424928,385116,193935,761381,407637,304636,153402,279540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]