SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534683 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534683 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384894,1022115,476925,934771,382814,808700,627796,624397,502142,456784,484012,574513,99732,200769,629403,806763,1012196,347302,685440,730316,898529,241617,412694,491516,215483,739907,557640,939390,907278,373722,424314,460424,611155,897527,898372,955776,668202,789661,261843,642442,850461,799680,760940,587336,265693,414251,996786,477054,30006,688913,631958,683418,498428,852160,189485,393592,260855,266812,800885,802764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]