SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 880801 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 880801 [ RunTime:0.007153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002917,4051,654751,41705,516093,351674,469419,472406,433875,845554,732358,442003,489569,116144,500037,353680,714720,712012,32790,640893,229685,718926,89414,527658,548220,754723,602746,133556,560108,92123,74179,896895,619981,86057,267308,670889,910624,910040,96986,1031802,318824,406688,978047,365971,222737,664963,508981,480291,497052,919085,712582,89661,534955,153837,273679,218130,531292,384306,821005,657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 880801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 880801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001091s ]