SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456441 LIMIT 1 [ RunTime:0.001241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456441 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194679,331526,415601,233315,331051,550006,813263,858741,613498,388748,150052,779581,167199,904633,854565,410368,664840,1041874,1026723,322054,672585,798289,858758,528381,785014,444436,741634,263452,1018246,781443,480371,871707,975159,390034,420881,168334,735913,480087,331241,33033,1024353,867579,1013562,176109,47824,982310,512670,535396,777541,732639,933780,821796,173250,1039108,296183,718536,600106,805432,586177,263434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]