SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018511 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018511 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766065,674781,71123,10423,614263,538737,68150,171066,950028,4408,475636,386303,735051,405941,997930,510968,248704,713191,460449,650523,616113,550290,110269,84409,744305,755803,1047120,885502,297337,828910,208590,623069,63732,550329,238545,405856,642088,437098,250098,33658,609123,680679,145507,168675,897371,69294,101963,1019386,418134,122417,910423,657909,930083,70716,1031643,497437,777109,1032951,147806,928667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]