SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040618 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040618 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495367,332833,509067,832901,618227,435760,721058,321044,779720,647138,224659,474508,224839,470797,384004,926796,1039641,611511,308145,492070,224377,666580,238456,735090,419063,410167,957244,208633,308825,986344,288927,740303,261327,319610,352635,969408,488066,370384,951729,738444,882817,641691,647409,788457,187423,976773,742640,212733,257390,744026,924141,248921,672190,180280,812628,286407,5716,541358,426438,433043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]