SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982961 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982961 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538728,228148,705119,410180,313430,871143,62360,308192,698349,116314,438368,526496,833427,380627,881156,508569,978749,230731,801267,869254,669523,440238,552341,300522,309024,309547,782478,1044950,1001450,369791,709852,387283,199520,399337,257381,375655,117363,691824,842772,258863,396232,182014,533853,682897,161075,563722,757880,120218,373457,158109,938339,260513,210987,1014088,5673,211527,873842,298010,518597,528510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001404s ]