SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596689 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596689 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89310,192864,886984,584714,140571,627565,455038,359774,699007,392619,124667,1018001,881138,10180,574121,885601,881714,1005025,213007,362880,449140,341177,438226,367486,61504,336706,727151,730912,321661,1011655,578810,457901,93778,353676,518983,118093,178555,922643,129685,501621,244149,267399,266567,600874,476596,884592,418332,110610,431147,422957,703384,292916,1018229,12736,480007,1007421,1026340,768147,891889,775266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]