SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402144 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402144 [ RunTime:0.004024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105927,19182,463130,5696,655134,469600,320458,781258,47020,62958,641530,430755,539824,705382,547720,713984,383532,682681,13313,207274,597290,270844,380388,329474,742184,635925,557458,418237,103818,824850,611298,727958,784932,217153,221114,325032,978211,870022,64818,882280,159734,706853,148423,618662,825606,957197,164674,966162,628451,404389,426327,551411,337770,400,836440,602134,689024,313360,286418,307370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]