SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414721 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414721 [ RunTime:0.002952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438580,669,473740,667143,981507,409701,74503,942646,981388,891006,990714,557611,950979,678835,470345,76397,615539,875210,92031,154483,146058,753817,112166,655244,157344,532654,783371,165564,904554,764858,558012,42269,731214,299411,123996,822494,199272,137734,350895,311305,776688,581559,677040,574877,45873,196155,665035,540757,706868,766510,967640,232721,424275,126756,628600,1039875,1031095,784554,570325,1035207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]