SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464399 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464399 [ RunTime:0.003617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52914,226681,621446,597058,90591,1005392,409770,831110,151748,697351,325583,1023775,993276,202283,267363,206188,949907,619995,959088,748108,114031,139844,136489,34585,177072,260869,858517,473013,794826,760290,959965,176213,825105,815105,665958,669293,984423,194533,208128,961453,917881,925022,840396,434163,44142,461953,778583,747032,16669,325133,313094,1048042,664526,35149,1007764,27884,879817,486563,212968,921502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]