SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406188 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406188 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577531,805221,19981,581461,820110,534493,1045761,1034914,212649,477636,985665,225294,287650,859523,946338,647282,833567,136862,571013,179795,872256,140686,522418,998232,376658,156413,328622,1005800,419854,325928,159847,482961,62692,950578,696493,111968,975674,235554,882985,364672,812649,464912,457862,405106,508853,494662,811180,752937,1027616,594207,280642,72842,499433,449505,593997,184462,84449,223326,64684,678469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]