SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364984 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364984 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020147,434329,654854,702206,93198,579923,506814,551062,953657,707627,710604,1010083,562029,515463,10073,970818,909775,737217,628145,112907,867885,962145,128064,405134,1038972,616221,227823,525754,141149,1022411,561181,115687,358489,352803,789846,188449,742438,439222,219604,743009,714658,525714,870471,371280,351917,437158,248915,520812,569469,719281,157771,59462,1000929,309255,642640,992057,428617,868224,698061,822217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002149s ]