SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802535 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802535 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63378,842231,601901,525654,386099,944444,12277,1034189,330001,1041210,902197,852699,121425,820118,426358,898155,380328,505284,264003,282451,827816,252122,604285,350198,838289,780809,521970,572264,240860,471544,620761,749416,356633,501001,172473,413157,1018465,497852,443114,1044161,504169,52043,139631,158420,1035438,974189,252653,765321,877796,273736,217505,52562,653687,432616,953953,756995,727167,986468,157141,534980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000974s ]