SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536692 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536692 [ RunTime:0.002282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144414,774164,739039,704669,626437,446320,610796,3028,545120,458379,949871,717475,110462,427327,43252,644660,888209,1044837,896135,1045696,802750,101466,602166,508218,1017385,647445,105671,735426,126275,796048,724838,100001,771290,720450,293761,228351,816439,496086,423096,330623,993251,254598,162365,669801,444249,729889,716885,435172,890,401161,897413,176616,352510,391596,332351,297080,714451,3498,442704,272145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]