SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281993 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281993 [ RunTime:0.003656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326016,35994,1001931,91382,27256,664427,304223,678885,937034,776620,525348,20514,1036611,764796,377210,571876,100813,387670,793119,74481,907509,520756,305610,20473,196880,995973,464986,332605,898155,16460,412069,675166,912681,957175,571611,654799,820952,265854,916080,482419,122114,99134,940470,883633,144814,776261,355613,479192,381278,418266,815882,1007754,715279,281763,212709,130654,995096,302222,787656,754788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]