SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103620 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103620 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920522,110660,595911,72797,935827,859056,524168,145063,416333,201294,220021,1023713,498221,777315,831010,921356,801459,384878,981241,814419,979228,136951,349848,992538,321997,971994,557638,391691,146839,944684,253613,917524,127310,256163,874005,783667,398713,374715,437562,489197,860277,415626,227035,62199,676069,902269,287817,858309,992347,201934,810636,297022,354723,282652,855047,226101,682247,699688,477723,800507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]