SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529030 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529030 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530402,1044011,204866,975197,381840,717398,577609,162095,161475,686300,167289,375660,238500,891161,327567,838789,470335,269990,850857,618130,644095,402049,65357,642842,752420,226461,691397,498082,888817,375220,31627,438437,865828,130673,384646,414336,1028482,250741,948985,2968,363550,298671,483699,316207,222667,95681,139985,244767,960697,735703,390898,159606,706717,990904,365006,807329,136705,780203,696500,1033821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]