SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40638 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40638 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967238,101611,533998,1022957,176183,733630,108041,814758,383581,166923,859604,128089,700602,572642,33590,843856,706062,581796,357251,954418,381342,243536,864859,111095,872843,358039,966264,499888,629917,119627,803695,153906,846942,58706,570872,1039224,633588,66995,386778,523950,91964,380954,947508,226547,39854,11978,643437,621087,201976,570769,260990,95938,1026883,595733,689805,533192,718192,189625,448082,820427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]