SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917053 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917053 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526028,229762,15089,635849,399340,850109,167845,948682,92988,621201,102289,447662,864959,718823,545100,184470,198036,115998,449718,478368,182791,412215,699135,714212,992089,229178,198555,75193,197877,807981,9750,838508,33076,333016,297951,1018241,516876,639556,815439,155497,566033,80949,282806,229730,824649,707619,47353,18072,26026,371328,456365,703883,811403,711039,2411,165433,150305,850362,235381,1041644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]