SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41611 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41611 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959971,535884,499049,556561,955380,185588,554272,591082,11449,333644,278485,1030258,774861,499800,227571,631326,409122,888386,546079,233966,431570,622915,761046,840835,377081,174162,768679,766784,376572,643462,114624,797968,879558,672159,599768,579679,728644,908677,252377,854828,183329,409549,395779,777354,947454,179790,811441,55188,934649,267012,914271,84620,355284,546912,736051,460112,392079,922660,883621,222417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001890s ]