SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544671 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544671 [ RunTime:0.005008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544274,29429,459706,848531,817358,304480,325651,618992,332198,1027447,756984,272831,255749,135664,911963,806031,967364,278351,666289,783240,1025504,977674,993877,938467,507367,351245,986244,8625,602964,997938,435976,854247,979026,85428,507660,400611,308339,516857,767879,111298,852430,662891,958297,960631,960944,856782,637588,190201,1030149,131411,994665,154309,27287,500070,735723,268649,1017073,284576,459238,118441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]