SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 288040 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 288040 [ RunTime:0.004170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505340,509947,800598,576338,544418,136855,466076,920641,1003830,503516,810806,562096,768996,207772,372481,544386,268488,949384,958153,848874,704210,181839,153686,1000232,499049,53250,403454,252752,643175,63565,199302,458309,363154,205757,380742,108295,852338,757290,772647,121699,564167,810387,801451,74803,803345,434889,418305,207141,451761,509248,148370,844434,575038,299101,928965,33816,23070,549127,631649,49697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 288040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 288040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]