SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559043 LIMIT 1 [ RunTime:0.004214s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559043 [ RunTime:0.004805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415890,183010,117206,951225,51778,333777,806325,220960,788740,439155,243956,477145,160073,17662,904605,343871,437469,970861,607059,280775,824577,885556,644738,842519,653325,735237,404352,974296,394900,266539,603390,969887,132844,822238,60366,577096,266114,679060,667318,824100,288780,277533,78346,96607,561760,244216,633820,477271,668563,961217,611567,221806,363752,411938,140328,307292,1005998,545122,546004,89797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]