SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50851 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50851 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50317,85118,371988,1048514,175529,586691,265704,778254,693368,662449,787362,462529,409257,175685,643059,521308,419917,570184,1001820,187969,676889,527228,697087,172952,358343,321660,209324,415366,186537,761716,937348,578622,51409,942528,334423,831630,270752,346410,308155,736664,636057,258576,66843,186224,392318,923905,490817,274890,362323,440679,683859,773148,711199,226985,323694,241687,30287,413621,351193,566629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]