SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199653 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199653 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553243,358605,451671,511631,310306,951204,436826,496425,201909,1015282,618345,683924,678003,741478,749960,491779,632997,952650,104417,880903,220119,575483,35120,109974,563777,736798,22417,497182,914093,868144,394397,727504,92558,425424,296353,867242,560197,207838,899976,424112,535799,863215,127179,915136,880740,755788,270499,601175,785404,827129,746197,631440,715827,174266,658604,804039,311451,302717,967848,625274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001181s ]