SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405324 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405324 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956824,898007,859108,443560,75832,36399,859547,834362,591793,811868,546767,974058,233021,812416,169624,1045201,355792,869726,715891,403626,843484,1020185,719108,738857,105114,47330,902926,268318,867301,552976,612803,419176,905989,484435,96864,686768,589325,495826,614268,527807,827017,800609,115007,45505,368769,988378,751111,75298,718212,630993,261091,878461,18991,979274,1001715,330009,446459,93229,435702,686453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]