SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046147 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046147 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526537,743710,1012125,25365,41651,1000294,731654,815905,478745,636789,886943,329027,211888,567268,564941,14886,605844,718525,963022,397310,170954,83784,287211,754021,855858,514595,493816,778041,87350,600917,631467,734965,610510,783377,606576,501856,702321,458921,197075,435769,421490,857384,299809,227962,523564,694792,251356,1026060,787252,857245,84578,458078,212621,393587,581341,883484,411711,990951,670980,429097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]