SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10967 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10967 [ RunTime:0.001352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64990,437351,890,50108,650880,744015,841426,470232,149868,192146,403865,509149,608560,772497,323554,938090,862151,748669,436498,804414,913500,581724,253030,506097,1031037,356047,882561,757567,642322,75311,999213,823149,174162,381330,272335,548042,532513,704825,843885,791781,783237,1020894,665861,928867,451139,311595,773075,627489,801257,73531,846856,424430,135611,134743,166558,680900,1006162,531497,622139,5036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]