SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002597s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444580 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444580 [ RunTime:0.004149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186350,180051,945202,655061,17845,432584,238486,202669,556589,824406,560127,501088,224121,76994,45589,1023860,534574,489189,347178,226539,354308,1024503,530324,574400,377600,730048,345772,527936,928485,667545,177842,343149,685678,1008592,1024358,860687,571976,606966,501270,140230,250505,274258,477671,506665,359095,717097,261554,748483,459558,163693,532328,655745,19642,433797,644846,268255,19826,1045337,736983,15691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003129s ]