SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439831 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439831 [ RunTime:0.002790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827122,842965,110588,527683,737953,58204,606464,908828,489853,99033,524683,534442,682678,655312,671388,996706,602297,675328,175958,227646,982419,1034174,632765,187933,405894,103765,848277,431460,877988,627546,455091,178221,423386,410704,475507,414273,427114,422934,32149,756552,424857,946485,593244,870678,455353,238324,662421,998406,1032366,985847,112934,880998,792020,445546,832317,982105,45966,548465,973108,889689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]