SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385112 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385112 [ RunTime:0.003592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413217,435695,159390,639191,263075,456769,275297,163946,290033,607013,981239,639664,146151,54335,557502,885373,101859,803522,345485,149597,418830,736883,630749,725330,1001208,528894,670797,244592,1038676,467431,960771,940677,434140,726117,1017467,613989,170621,318915,1042683,614309,1012478,152538,473959,586540,942438,541738,1025513,258063,73081,531752,477036,334616,173789,99391,186333,465719,757748,520837,10687,168596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001514s ]