SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003624s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802053 LIMIT 1 [ RunTime:0.006754s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802053 [ RunTime:0.007424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259899,977909,782342,37416,44030,325344,8194,150605,595825,451579,863569,941512,1013477,127943,386462,203,441776,1041527,125795,510936,601067,659812,46566,467635,755515,306279,298959,253001,609274,99188,119162,424127,948258,868017,340027,208534,620499,93574,968861,45381,514344,316962,369542,443733,130168,607528,949498,607322,1031331,605972,1011345,556474,30290,880553,409118,347024,372813,722521,274704,151382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]