SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401044 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401044 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975980,208325,528310,279525,693282,821677,252885,910144,690947,735721,625004,651114,634936,510331,818911,449934,986731,598560,555438,147589,48950,382773,137336,720363,913435,1047719,866793,922452,125307,159649,566965,729882,365596,595821,624010,116163,392407,622578,442665,729318,431485,556583,97286,608734,556622,730355,844498,575120,313910,752364,739743,630788,716659,788196,946217,910258,236769,634663,282404,409384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]