SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596398 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596398 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679602,998717,458486,154822,709353,667678,117496,56217,875134,236631,536645,546656,574739,362054,73383,99450,452636,656224,979346,236028,821795,73661,72913,667358,555413,203396,168050,748646,707097,939482,539155,105482,782310,186307,339139,603102,807706,222221,206925,319336,399808,262482,726516,983873,765159,201660,637872,539092,505187,650176,429565,834286,1018241,211739,892373,289743,271635,222526,1038886,970058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]