SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111810 LIMIT 1 [ RunTime:0.002326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111810 [ RunTime:0.007641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815791,691694,498604,158047,1007878,356757,898812,561766,914561,873623,509281,272967,76314,288641,448126,342606,718427,693659,516474,652977,795878,61192,985429,525416,898829,322198,54543,646616,328958,33991,587017,666787,535143,986238,423700,191923,961372,462379,274492,44804,57530,645266,563611,104250,530681,895913,681560,114551,985086,700803,827803,423642,913736,989586,545598,300126,763425,857281,295926,898268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001031s ]