SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503254 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503254 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612221,156450,578934,330563,745670,724070,307245,871904,847015,355522,433828,424685,381436,947509,1017848,629073,843969,577712,352822,703765,744281,700242,856421,874599,356830,780715,149961,840633,868699,28927,896453,212701,494940,739286,337632,127383,692094,237950,832539,5927,957688,21853,969854,332939,174047,231541,919243,639558,700615,391632,297832,954999,492354,748937,280480,635362,237252,490048,27740,219160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]