SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504009 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504009 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179113,433048,61323,740530,996487,644079,383303,850961,34523,1002548,270590,762786,1030028,377289,452795,638147,552954,359549,790273,202973,642730,736612,465944,780166,504367,121705,449050,355165,610839,441949,799772,186411,473993,591360,99652,940383,488437,74719,505181,821466,978924,578268,560721,845382,384131,460498,818563,930979,95267,796202,877392,93518,725888,301899,29400,139234,662047,404097,299566,793679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001891s ]