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` = 808180 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808180 [ RunTime:0.004144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000516,653524,935904,2617,149303,311095,739230,178941,48401,750142,84481,562357,479757,781400,1037295,606727,718126,121817,903678,341998,830844,670638,481931,931897,214590,235159,25370,173352,70295,873481,101809,805999,954738,1000799,888862,999196,96266,656239,129820,1030888,525231,312790,149823,460498,942552,326884,856571,562191,318659,923552,76130,748892,1026815,653528,915659,949249,1028504,954003,774654,152214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]