SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590056 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590056 [ RunTime:0.002653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869683,279725,126894,399894,963620,659889,182550,1009904,666725,1027643,144609,352962,979113,416491,569868,907240,895350,528133,435569,306091,365840,815873,35411,100961,658592,228003,998789,897979,778674,926768,177646,940977,347260,525040,869686,1003578,231053,838546,197095,529932,214340,44277,770303,33446,961980,1013353,76967,485264,518504,832993,355600,1010965,232391,990144,705216,55438,816739,513496,296439,1027185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]