SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481063 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481063 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67809,611450,385632,195932,158052,532106,287677,900627,9913,979984,112509,111374,507338,569151,75002,916222,472482,10893,812833,842353,838377,397792,931451,766614,525218,563935,870336,73180,145462,449250,29149,953183,860523,663884,340569,837056,412137,742342,789210,670439,683839,470306,105289,882318,167071,71699,1003746,80131,507458,1009156,313104,172764,214726,174968,879178,465487,529542,323297,998240,594028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]