SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445766 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445766 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213386,241374,983634,1040803,733133,795331,572457,728455,99434,562936,65844,38414,120876,850415,338277,540996,365712,948648,781310,898658,877155,262073,165939,442067,1007398,372091,241130,725837,22414,716081,219149,641522,33056,152159,324954,705507,758143,433347,473147,824631,997764,389572,787244,185567,93159,297636,1025595,486357,832596,1032295,725033,816284,95660,316908,840844,90386,750338,91642,429725,822024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]