SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668551 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668551 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041236,359513,181895,695908,281504,75202,954303,826013,646385,133051,210468,249642,2672,702220,179497,987023,219040,875561,227764,577356,104603,125502,892121,965281,252814,866479,218570,482226,59340,962312,491857,429310,823907,365054,397611,590847,604258,447731,1008040,134932,598276,297107,499536,281400,43133,348091,362737,961558,282479,336696,471484,891513,309364,881532,884261,805445,333433,726914,278541,167654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]