SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46494 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46494 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282456,842569,287777,849028,592023,631667,610445,1001010,691141,655899,116611,946034,1014560,76638,428461,67342,32554,560950,594531,293795,137842,1026708,752152,1013913,910968,574295,985061,91173,1046740,662471,392468,515375,931517,531582,877,269285,333574,101694,439192,999028,655814,345197,637315,492437,553188,289229,334145,499331,1009263,898900,837638,150691,306133,658150,229507,741322,572425,278746,682537,597415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]