SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583595 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583595 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013180,791213,675282,735675,91373,944341,167301,390161,477855,555952,1027614,658494,832933,45174,400254,557075,917493,307244,581287,368773,97502,97561,727049,545142,699240,507356,2047,790104,880258,42437,369463,398675,527032,737569,628334,642367,461849,623277,885224,716361,520897,49250,1037944,691498,545755,915116,177982,917742,540525,772074,361031,724923,549400,969285,64389,548850,457045,128422,787522,672221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]