SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535712 LIMIT 1 [ RunTime:0.001086s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535712 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899869,128594,113685,954731,459837,375200,135898,1044931,179702,622817,22956,4466,553182,358802,578940,629038,239259,194084,935303,621505,898226,635032,608788,1028225,493674,578083,897558,197192,230812,224675,99624,694144,490888,574686,714970,283569,725389,644538,1000134,719128,660246,15371,698137,600118,13110,164992,499780,924633,878231,285910,833563,407292,517170,349007,375197,472326,446235,442984,41813,307464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]